Or operator

Basic and Crystal syntax.

Usage

x Or y

Value of x Value of y x Or y

True

True

True

True

False

True

False

True

True

False

False

False

Examples

The following example is applicable to Crystal syntax:

If {file.CREDIT LIMIT} = 5000 or {file.SALESMAN} = "SP"

Then

    {file.AMOUNT}

Else

    0;

This means that if the credit limit is 5000, or, if the salesman is SP, (either of the conditions are true), then it returns the value in the {file.AMOUNT} field; otherwise it returns nothing.

The following examples are applicable to both Basic and Crystal syntax:

A > B or B > C

TRUE, where A = 10, B = 6, and C = 3 (both conditions true).

A > B or B > C

TRUE, where A=10, B=6, and C=7 (either one of the two conditions true).

A > B or B > C

FALSE, where A=5, B=6, and C=7 (neither of the two conditions true).

(A>B) or (A * C - D > E) or (E / D<= B)

TRUE, where A = 5, B = 5, C = 3, D = 2, E = 12 (At least one of the three conditions is true. In this case only (A * C - D > E) is true).

Related topics

Formula 6



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com